Tabela PrescriptionDrugActiveSubst

Definicja tabeli PrescriptionDrugActiveSubst

Name

PrescriptionDrugActiveSubst

Code

PrescriptionDrugActiveSubst

Comment

Substancje czynne dla leku na recepcie


Lista kolumn tabeli PrescriptionDrugActiveSubst

Name

Code

PrescriptionDrugID

PrescriptionDrugID

DrugActiveSubstID

DrugActiveSubstID

DosageQuantity

DosageQuantity

DosageUnit

DosageUnit

DosageInWords

DosageInWords


Kolumna PrescriptionDrugID tabeli PrescriptionDrugActiveSubst

Definicja kolumny PrescriptionDrugID tabeli PrescriptionDrugActiveSubst

Name

PrescriptionDrugID

Code

PrescriptionDrugID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

lek na recepcie


Kolumna DrugActiveSubstID tabeli PrescriptionDrugActiveSubst

Definicja kolumny DrugActiveSubstID tabeli PrescriptionDrugActiveSubst

Name

DrugActiveSubstID

Code

DrugActiveSubstID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

substancja czynna


Kolumna DosageQuantity tabeli PrescriptionDrugActiveSubst

Definicja kolumny DosageQuantity tabeli PrescriptionDrugActiveSubst

Name

DosageQuantity

Code

DosageQuantity

Data Type

NUMBER(18,8)

Mandatory

No

Comment

laczna ilosc substancji czynnej


Kolumna DosageUnit tabeli PrescriptionDrugActiveSubst

Definicja kolumny DosageUnit tabeli PrescriptionDrugActiveSubst

Name

DosageUnit

Code

DosageUnit

Data Type

VARCHAR2(16)

Mandatory

No

Comment

jednostka substancji czynnej


Kolumna DosageInWords tabeli PrescriptionDrugActiveSubst

Definicja kolumny DosageInWords tabeli PrescriptionDrugActiveSubst

Name

DosageInWords

Code

DosageInWords

Data Type

VARCHAR2(256)

Mandatory

No

Comment

laczna ilosc substancji czynnej slownie


Lista kluczy tabeli PrescriptionDrugActiveSubst

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PrescriptionDrugActiveSubst

Definicja klucza Identifier_1 tabeli PrescriptionDrugActiveSubst

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment